/**
 * @author MIAO
 * Created on 2011-10-31
 * For more information, please visit:ismiao.com
 */
package com.ismiao.spring.jdbcTemplate;


public class TestCallableStatement {
	public static void main(String[] args) throws Exception {
//		String userID = javax.swing.JOptionPane.showInputDialog(null, "输入客户号");
//		String userName = javax.swing.JOptionPane.showInputDialog(null,
//				"输入客户姓名");
//		Class.forName("com.mysql.jdbc.Driver");
//		Connection conn = DriverManager
//				.getConnection("jdbc:mysql://localhost:3306/test","root","root");
//		CallableStatement cs=conn.prepareCall
//				("{call prc_userName(?, ?)}"); 
//		//设置IN参数  
//        cs.setString(1,"0001");  
//        //注册OUT参数  
//        cs.registerOutParameter(2, java.sql.Types.CHAR);  
//        //执行存储过程  
//        cs.executeQuery();  
//        //获取参数值  
//        String result=cs.getString(2);  
//		conn.close();
	}
}
